
/*
{
"状态":1,
"名称":"删除-权限导航树",
"作者":"马学兵",
"创建时间":"2018-08-20",
"功能":"删除-权限导航树",
"log": [
	{"date":"" , "dev" :"" , "content" : ""}
]
}
*/
DECLARE @power_tree_key int

Set @power_tree_key='{power_tree_key}'

if @power_tree_key in(1,2,3)
begin
	RAISERROR ('SQL:系统默认类别,不允许删除', 16 ,1 ) ; 
	return 
end

DELETE FROM [y_power_tree] WHERE power_tree_key=@power_tree_key